package com.huitone.smspfm.dao.oracle;

import java.util.List;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import com.huitone.smspfm.dao.oracle.entity.InvalidUse;

public class InvaliduseDao extends BaseDao<InvalidUse> {

	@Override
	public List<InvalidUse> getAllObj() {
		return jdbcTemplate.query("SELECT * FROM " + tableName + " WHERE STATUS = '1'", new BeanPropertyRowMapper<InvalidUse>(InvalidUse.class));
	}
	
	/**
	 * 获取所有无效用户
	 * @return
	 */
	public List<String> getInvalidUsers() {
		return jdbcTemplate.queryForList("SELECT invalid_user FROM " + tableName + " WHERE STATUS = '1'", String.class);
	}

}
